namespace EFMysql
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("www_test.pre_user_search")]
    public partial class pre_user_search
    {
        [Key]
        [Column(TypeName = "uint")]
        public long userid { get; set; }

        [Required]
        [StringLength(30)]
        public string username { get; set; }

        [Required]
        [StringLength(40)]
        public string password { get; set; }

        [StringLength(30)]
        public string name { get; set; }

        [StringLength(20)]
        public string shopid { get; set; }

        [StringLength(20)]
        public string tel { get; set; }

        [StringLength(50)]
        public string email { get; set; }

        [StringLength(20)]
        public string qq { get; set; }

        [Column(TypeName = "uint")]
        public long createtime { get; set; }

        [Column(TypeName = "uint")]
        public long updatetime { get; set; }

        [Column(TypeName = "uint")]
        public long createid { get; set; }

        [Column(TypeName = "uint")]
        public long updateid { get; set; }

        [Column(TypeName = "char")]
        [Required]
        [StringLength(20)]
        public string role { get; set; }

        public int logtime { get; set; }

        [StringLength(30)]
        public string logip { get; set; }

        public decimal balance { get; set; }

        public bool islive { get; set; }

        public int belongto { get; set; }

        public int logcount { get; set; }

        public int ordercount { get; set; }

        [StringLength(255)]
        public string sendway { get; set; }

        [StringLength(255)]
        public string haveshiptype { get; set; }

        public int? membertype { get; set; }

        public int? memberlevel { get; set; }

        [StringLength(50)]
        public string createip { get; set; }

        [StringLength(1073741823)]
        public string markuplist { get; set; }

        public int? promoteid { get; set; }

        public int? showaddr { get; set; }

        public decimal? GoldCoinAmount { get; set; }

        public int? totalpage { get; set; }

        public int? totalcount { get; set; }

        public int? duringplan { get; set; }

        public int? promotecount { get; set; }

        public decimal? userrateval { get; set; }

        public decimal? userdiscountval { get; set; }

        [StringLength(20)]
        public string spname { get; set; }
    }
}
